Shareware Grab Bag/Shareware Grab Bag.iso/019/cellnote.arc/CELLNOTE.DOC

Text File | 1986-10-08 | 4KB | 195 lines

                        C E L L * N O T E
                          by Randy Brix




INTRODUCTION

Many of my worksheets have some "catch all" columns.  Whenever an
entry is made to these a note must be manually  placed  somewhere
else on the worksheet.  This being rather annoying prompted me to
design  a macro that would do it for me.   CELL*NOTE is  a  macro
which  allows  the  user to "attach" a note to any  cell  on  the
worksheet.



REQUIREMENTS

HARDWARE:  An  IBM PC/XT or compatable with enough memory to  run
           LOTUS 1-2-3.

SOFTWARE:  This   macro  has  only been tested  with Lotus  1-2-3
           release 1A.



GETTING STARTED

To get CELL*NOTE onto a worksheet do the following:

- Load the worksheet which you would like CELL*NOTE on.

- Place the cursor to the cell where you want the top left corner
  of the macro to be.

- Combine "CELLNOTE" to your worksheet (if you're not sure how
  to do this see your LOTUS 1-2-3 manual).

- Move the cursor one cell to the right.

- The  cursor  is now  on a  small  macro  which  will  "install"
  CELL*NOTE.   Type the following:   /rnc\i  [enter]  [enter] (If
  you  already have a macro called "\I",  then assign it  another
  letter).

- Activate  the "install" macro by holding down the alt  key  and
  the "I" key (or whichever letter you assigned to it).










                               -1-









MAKING NOTES

To  invoke CELL*NOTE move the cursor to a cell to which you would
like a note attached, then hold down the alt key and the "N" key.
This  will  bring  up  a menu which will  allow  you  to  do  the
following:

CREATE - Create a new note.

VIEW - Look at an existing note.

EDIT - Change an existing note.

DELETE - Delete an existing note

RETURN - Returns  the cursor to the cell from which CELL*NOTE was
         called.



PRECAUTIONS AND LIMITATIONS

- CELL*NOTE  should not be used with a worksheet that  will  have
  columns or rows inserted or deleted.  This macro is not capable
  of adjusting the notes as the cell locations change.

- Only one 256 character note is allowed per cell.

- If  you call CELL*NOTE while in the "windows" mode this will be
  cancelled upon returning to the original cell.

- If  your worksheet has the "titles" set,  CELL*NOTE will remove
  them but not  restore them.   I suggest that you create another
  macro which will set the titles.

- CELL*NOTE  stores  the  notes in a database and thus  uses  the
  Query function.  This macro will not work properly if your work
  sheet use the command also.



RANGE NAMES

I am including a list of the range names that I use in CELL*NOTE.
If  your  worksheet has  some  of  these same  names,  I  suggest
that it would probably be easier to change the range name on your
worksheet.   If you can  understand my macro please feel free  to
make the change there.  The following is a list of range names:

CORNER      END      EXCELL      EXMESS      GARB      ID

INP         MENESC   MESS        NMENU       TL        \I      \N




                               -2-







CLOSING COMMENTS

I must admit that this macro is limited to certain kinds of work-
sheets.   The  worksheets that I use CELL*NOTE with are  for  the
most  part  reports  and do not require "windows"  or  the  Query
function.   I  encourage  you  to modify this macro to  your  own
needs.   If you find ways to get around the problems listed under
PRECAUTIONS AND LIMITATIONS the more power to you.


LOTUS 1-2-3 is a product of Lotus Development Corp.
IBM is a trademark of International Business Machines Corp.














































                               -3-